import pandas as pd
pd.set_option('display.unicode.east_asian_width', True)
df = pd.read_excel('城镇单位就业人员年平均工资.xlsx', sheet_name='按登记注册类型', index_col=0)
df.drop('数据来源：国家统计局', inplace=True)
print('删除数据后的城镇单位就业人员年平均工资: \n', df)
df.loc['外商投资单位']=['112089','1066604','99367','90064','82902','76302','69826','63171','55888','48869','41739','37101','34250','29594','26552','23625','22250','21016','19409','17553']
print('增加数据后的城镇单位就业人员年平均工资: \n', df)
writer = pd.ExcelWriter('按登记注册类型城镇单位就业人员年平均工资.xlsx')
df.to_excel(writer, sheet_name='按登记注册类型')
